0: The catalogdb is 9205, catalog is 9205, backupdb is 8174, RMAN used to backup is 8174

1: Taking the first level 
    RMAN> change archivelog all crosscheck;

RMAN-03022: compiling command: change
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000010.arc recid=117 stamp=532794117
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000011.arc recid=118 stamp=532794117
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000012.arc recid=119 stamp=532794118
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000013.arc recid=120 stamp=532800162
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000014.arc recid=121 stamp=532800162
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000015.arc recid=122 stamp=532800162
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000016.arc recid=123 stamp=532800410
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000017.arc recid=124 stamp=532800410
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000018.arc recid=125 stamp=532800410
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000019.arc recid=126 stamp=532801084
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000020.arc recid=127 stamp=532801085
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000021.arc recid=128 stamp=532801085

RMAN> run { execute script  backup_db_level_0_disk; }

RMAN-03021: executing script: backup_db_level_0_disk

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=17 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=15 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=384 set_stamp=532802281 creation_time=29-JUL-2004 16:38:01
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=/db01/oradata/desrep3/rbs.dbf
RMAN-08522: input datafile fno=00003 name=/db02/oradata/desrep3/des2.dbf
RMAN-08008: channel d2: starting incremental level 0 datafile backupset
RMAN-08502: set_count=385 set_stamp=532802281 creation_time=29-JUL-2004 16:38:01
RMAN-08010: channel d2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00004 name=/db01/oradata/desrep3/des2_i.dbf
RMAN-08522: input datafile fno=00001 name=/db00/oradata/desrep3/system.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802281_s384_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:49
RMAN-08008: channel d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=386 set_stamp=532802392 creation_time=29-JUL-2004 16:39:52
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00005 name=/db01/oradata/desrep3/temp_1.dbf
RMAN-08522: input datafile fno=00006 name=/db01/oradata/desrep3/tools.dbf
RMAN-08013: channel d2: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:51
RMAN-08008: channel d2: starting incremental level 0 datafile backupset
RMAN-08502: set_count=387 set_stamp=532802393 creation_time=29-JUL-2004 16:39:53
RMAN-08010: channel d2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00008 name=/db00/oradata/desrep3/users.dbf
RMAN-08522: input datafile fno=00009 name=/db00/oradata/desrep3/TEST2.dbf
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802392_s386_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:17
RMAN-08008: channel d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=388 set_stamp=532802409 creation_time=29-JUL-2004 16:40:09
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=/db02/oradata/desrep3/tools_ind.dbf
RMAN-08013: channel d2: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802393_s387_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:16
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802409_s388_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:01
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: archive_log_current

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER DATABASE BACKUP CONTROLFILE TO TRACE
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM CHECKPOINT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM SWITCH LOGFILE
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM CHECKPOINT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
RMAN-03023: executing command: sql

RMAN-03021: executing script: backup_archive_all_wout_delete_disk

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=17 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=15 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08009: channel d1: starting archivelog backupset
RMAN-08502: set_count=389 set_stamp=532802420 creation_time=29-JUL-2004 16:40:20
RMAN-08014: channel d1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=10 recid=117 stamp=532794117
RMAN-08009: channel d2: starting archivelog backupset
RMAN-08502: set_count=390 set_stamp=532802420 creation_time=29-JUL-2004 16:40:20
RMAN-08014: channel d2: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=11 recid=118 stamp=532794117
RMAN-08504: input archivelog thread=1 sequence=12 recid=119 stamp=532794118
RMAN-08504: input archivelog thread=1 sequence=13 recid=120 stamp=532800162
RMAN-08504: input archivelog thread=1 sequence=14 recid=121 stamp=532800162
RMAN-08504: input archivelog thread=1 sequence=15 recid=122 stamp=532800162
RMAN-08504: input archivelog thread=1 sequence=16 recid=123 stamp=532800410
RMAN-08504: input archivelog thread=1 sequence=17 recid=124 stamp=532800410
RMAN-08504: input archivelog thread=1 sequence=18 recid=125 stamp=532800410
RMAN-08504: input archivelog thread=1 sequence=19 recid=126 stamp=532801084
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-08013: channel d2: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-08009: channel d1: starting archivelog backupset
RMAN-08502: set_count=391 set_stamp=532802422 creation_time=29-JUL-2004 16:40:22
RMAN-08014: channel d1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=20 recid=127 stamp=532801085
RMAN-08504: input archivelog thread=1 sequence=21 recid=128 stamp=532801085
RMAN-08504: input archivelog thread=1 sequence=22 recid=129 stamp=532801590
RMAN-08504: input archivelog thread=1 sequence=23 recid=130 stamp=532801590
RMAN-08504: input archivelog thread=1 sequence=24 recid=131 stamp=532801591
RMAN-08504: input archivelog thread=1 sequence=25 recid=132 stamp=532802417
RMAN-08504: input archivelog thread=1 sequence=26 recid=133 stamp=532802417
RMAN-08504: input archivelog thread=1 sequence=27 recid=134 stamp=532802417
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:01
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=385 set_stamp=532802281 creation_time=29-JUL-2004 16:38:01
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=384 set_stamp=532802281 creation_time=29-JUL-2004 16:38:01
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=385 set_stamp=532802281 creation_time=29-JUL-2004 16:38:01
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802281_s384_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=386 set_stamp=532802392 creation_time=29-JUL-2004 16:39:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802392_s386_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=387 set_stamp=532802393 creation_time=29-JUL-2004 16:39:53
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=388 set_stamp=532802409 creation_time=29-JUL-2004 16:40:09
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802393_s387_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802409_s388_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000010.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000011.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000012.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000013.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000014.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000015.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000016.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000017.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000018.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000019.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000020.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000021.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000022.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000023.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000024.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000025.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000026.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000027.arc

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: release_2_tapes

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t2


2. List after first backup:

RMAN> list backup of controlfile;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2491    361        532802387  0  532802281  385        29-JUL-2004 16:39:47

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2496    1   1   AVAILABLE   29-JUL-2004 16:39:47   /backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk

    Controlfile Included
    Ckp SCN    Ckp time
    ---------- ---------------
    4741673285 29-JUL-2004 16:38:01

RMAN> list backup;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2490    360        532802383  0  532802281  384        29-JUL-2004 16:39:43

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2495    1   1   AVAILABLE   29-JUL-2004 16:39:43   /backup/DESREP3/df_DESREP3_t532802281_s384_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    2    /db01/oradata/desrep3/rbs.dbf         0  Full 4741673285 29-JUL-2004 16:38:01
    3    /db02/oradata/desrep3/des2.dbf        0  Full 4741673285 29-JUL-2004 16:38:01

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2491    361        532802387  0  532802281  385        29-JUL-2004 16:39:47

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2496    1   1   AVAILABLE   29-JUL-2004 16:39:47   /backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    1    /db00/oradata/desrep3/system.dbf      0  Full 4741673286 29-JUL-2004 16:38:04
    4    /db01/oradata/desrep3/des2_i.dbf      0  Full 4741673286 29-JUL-2004 16:38:04

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2492    362        532802398  0  532802393  387        29-JUL-2004 16:39:58

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2497    1   1   AVAILABLE   29-JUL-2004 16:39:58   /backup/DESREP3/df_DESREP3_t532802393_s387_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    8    /db00/oradata/desrep3/users.dbf       0  Full 4741673288 29-JUL-2004 16:39:54
    9    /db00/oradata/desrep3/TEST2.dbf       0  Full 4741673288 29-JUL-2004 16:39:54

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2493    363        532802406  0  532802392  386        29-JUL-2004 16:40:06

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2498    1   1   AVAILABLE   29-JUL-2004 16:40:06   /backup/DESREP3/df_DESREP3_t532802392_s386_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    5    /db01/oradata/desrep3/temp_1.dbf      0  Full 4741673287 29-JUL-2004 16:39:52
    6    /db01/oradata/desrep3/tools.dbf       0  Full 4741673287 29-JUL-2004 16:39:52

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2494    364        532802409  0  532802409  388        29-JUL-2004 16:40:09

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2499    1   1   AVAILABLE   29-JUL-2004 16:40:09   /backup/DESREP3/df_DESREP3_t532802409_s388_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    7    /db02/oradata/desrep3/tools_ind.dbf   0  Full 4741673289 29-JUL-2004 16:40:09

RMAN> list backup of archivelog all;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2518    365        532802421  0  532802420  389        29-JUL-2004 16:40:21

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2521    1   1   AVAILABLE   29-JUL-2004 16:40:21   /backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    10      4741673032 4741673199 22-JUL-2004 09:09:56 29-JUL-2004 14:21:57

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2519    366        532802421  0  532802420  390        29-JUL-2004 16:40:21

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2522    1   1   AVAILABLE   29-JUL-2004 16:40:21   /backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    11      4741673199 4741673201 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    12      4741673201 4741673204 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    13      4741673204 4741673225 29-JUL-2004 14:21:57 29-JUL-2004 16:02:41
    1    14      4741673225 4741673227 29-JUL-2004 16:02:41 29-JUL-2004 16:02:42
    1    15      4741673227 4741673230 29-JUL-2004 16:02:42 29-JUL-2004 16:02:42
    1    16      4741673230 4741673239 29-JUL-2004 16:02:42 29-JUL-2004 16:06:50
    1    17      4741673239 4741673241 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    18      4741673241 4741673244 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    19      4741673244 4741673257 29-JUL-2004 16:06:50 29-JUL-2004 16:18:04

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2520    367        532802422  0  532802422  391        29-JUL-2004 16:40:22

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2523    1   1   AVAILABLE   29-JUL-2004 16:40:22   /backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    20      4741673257 4741673259 29-JUL-2004 16:18:04 29-JUL-2004 16:18:05
    1    21      4741673259 4741673262 29-JUL-2004 16:18:05 29-JUL-2004 16:18:05
    1    22      4741673262 4741673274 29-JUL-2004 16:18:05 29-JUL-2004 16:26:30
    1    23      4741673274 4741673276 29-JUL-2004 16:26:30 29-JUL-2004 16:26:30
    1    24      4741673276 4741673279 29-JUL-2004 16:26:30 29-JUL-2004 16:26:31
    1    25      4741673279 4741673292 29-JUL-2004 16:26:31 29-JUL-2004 16:40:16
    1    26      4741673292 4741673294 29-JUL-2004 16:40:16 29-JUL-2004 16:40:17
    1    27      4741673294 4741673297 29-JUL-2004 16:40:17 29-JUL-2004 16:40:17
3:  Taking another  level 0 backup again
RMAN>  run { execute script  backup_db_level_0_disk; }

RMAN-03021: executing script: backup_db_level_0_disk

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=17 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=15 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=/db01/oradata/desrep3/rbs.dbf
RMAN-08522: input datafile fno=00003 name=/db02/oradata/desrep3/des2.dbf
RMAN-08008: channel d2: starting incremental level 0 datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08010: channel d2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00004 name=/db01/oradata/desrep3/des2_i.dbf
RMAN-08522: input datafile fno=00001 name=/db00/oradata/desrep3/system.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:57
RMAN-08008: channel d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00005 name=/db01/oradata/desrep3/temp_1.dbf
RMAN-08522: input datafile fno=00006 name=/db01/oradata/desrep3/tools.dbf
RMAN-08013: channel d2: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:01:59
RMAN-08008: channel d2: starting incremental level 0 datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08010: channel d2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00008 name=/db00/oradata/desrep3/users.dbf
RMAN-08522: input datafile fno=00009 name=/db00/oradata/desrep3/TEST2.dbf
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:16
RMAN-08008: channel d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=/db02/oradata/desrep3/tools_ind.dbf
RMAN-08013: channel d2: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:16
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: archive_log_current

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER DATABASE BACKUP CONTROLFILE TO TRACE
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM CHECKPOINT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM SWITCH LOGFILE
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM CHECKPOINT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
RMAN-03023: executing command: sql

RMAN-03021: executing script: backup_archive_all_wout_delete_disk

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=17 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=15 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08009: channel d1: starting archivelog backupset
RMAN-08502: set_count=397 set_stamp=532803081 creation_time=29-JUL-2004 16:51:21
RMAN-08014: channel d1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=10 recid=117 stamp=532794117
RMAN-08009: channel d2: starting archivelog backupset
RMAN-08502: set_count=398 set_stamp=532803081 creation_time=29-JUL-2004 16:51:21
RMAN-08014: channel d2: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=11 recid=118 stamp=532794117
RMAN-08504: input archivelog thread=1 sequence=12 recid=119 stamp=532794118
RMAN-08504: input archivelog thread=1 sequence=13 recid=120 stamp=532800162
RMAN-08504: input archivelog thread=1 sequence=14 recid=121 stamp=532800162
RMAN-08504: input archivelog thread=1 sequence=15 recid=122 stamp=532800162
RMAN-08504: input archivelog thread=1 sequence=16 recid=123 stamp=532800410
RMAN-08504: input archivelog thread=1 sequence=17 recid=124 stamp=532800410
RMAN-08504: input archivelog thread=1 sequence=18 recid=125 stamp=532800410
RMAN-08504: input archivelog thread=1 sequence=19 recid=126 stamp=532801084
RMAN-08504: input archivelog thread=1 sequence=20 recid=127 stamp=532801085
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:01
RMAN-08013: channel d2: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-08009: channel d1: starting archivelog backupset
RMAN-08502: set_count=399 set_stamp=532803083 creation_time=29-JUL-2004 16:51:23
RMAN-08014: channel d1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=21 recid=128 stamp=532801085
RMAN-08504: input archivelog thread=1 sequence=22 recid=129 stamp=532801590
RMAN-08504: input archivelog thread=1 sequence=23 recid=130 stamp=532801590
RMAN-08504: input archivelog thread=1 sequence=24 recid=131 stamp=532801591
RMAN-08504: input archivelog thread=1 sequence=25 recid=132 stamp=532802417
RMAN-08504: input archivelog thread=1 sequence=26 recid=133 stamp=532802417
RMAN-08504: input archivelog thread=1 sequence=27 recid=134 stamp=532802417
RMAN-08504: input archivelog thread=1 sequence=28 recid=135 stamp=532803079
RMAN-08504: input archivelog thread=1 sequence=29 recid=136 stamp=532803079
RMAN-08504: input archivelog thread=1 sequence=30 recid=137 stamp=532803079
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:01
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000010.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000011.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000012.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000013.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000014.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000015.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000016.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000017.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000018.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000019.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000020.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000021.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000022.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000023.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000024.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000025.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000026.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000027.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000028.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000029.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000030.arc

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: release_2_tapes

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t2

4: Listing backup
RMAN> list backup of controlfile;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2491    361        532802387  0  532802281  385        29-JUL-2004 16:39:47

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2496    1   1   AVAILABLE   29-JUL-2004 16:39:47   /backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk

    Controlfile Included
    Ckp SCN    Ckp time
    ---------- ---------------
    4741673285 29-JUL-2004 16:38:01

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2544    369        532803041  0  532802932  393        29-JUL-2004 16:50:41

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2549    1   1   AVAILABLE   29-JUL-2004 16:50:41   /backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk

    Controlfile Included
    Ckp SCN    Ckp time
    ---------- ---------------
    4741673299 29-JUL-2004 16:48:52

RMAN> list backup;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2490    360        532802383  0  532802281  384        29-JUL-2004 16:39:43

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2495    1   1   AVAILABLE   29-JUL-2004 16:39:43   /backup/DESREP3/df_DESREP3_t532802281_s384_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    2    /db01/oradata/desrep3/rbs.dbf         0  Full 4741673285 29-JUL-2004 16:38:01
    3    /db02/oradata/desrep3/des2.dbf        0  Full 4741673285 29-JUL-2004 16:38:01

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2491    361        532802387  0  532802281  385        29-JUL-2004 16:39:47

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2496    1   1   AVAILABLE   29-JUL-2004 16:39:47   /backup/DESREP3/df_DESREP3_t532802281_s385_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    1    /db00/oradata/desrep3/system.dbf      0  Full 4741673286 29-JUL-2004 16:38:04
    4    /db01/oradata/desrep3/des2_i.dbf      0  Full 4741673286 29-JUL-2004 16:38:04

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2492    362        532802398  0  532802393  387        29-JUL-2004 16:39:58

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2497    1   1   AVAILABLE   29-JUL-2004 16:39:58   /backup/DESREP3/df_DESREP3_t532802393_s387_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    8    /db00/oradata/desrep3/users.dbf       0  Full 4741673288 29-JUL-2004 16:39:54
    9    /db00/oradata/desrep3/TEST2.dbf       0  Full 4741673288 29-JUL-2004 16:39:54

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2493    363        532802406  0  532802392  386        29-JUL-2004 16:40:06

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2498    1   1   AVAILABLE   29-JUL-2004 16:40:06   /backup/DESREP3/df_DESREP3_t532802392_s386_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    5    /db01/oradata/desrep3/temp_1.dbf      0  Full 4741673287 29-JUL-2004 16:39:52
    6    /db01/oradata/desrep3/tools.dbf       0  Full 4741673287 29-JUL-2004 16:39:52

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2494    364        532802409  0  532802409  388        29-JUL-2004 16:40:09

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2499    1   1   AVAILABLE   29-JUL-2004 16:40:09   /backup/DESREP3/df_DESREP3_t532802409_s388_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    7    /db02/oradata/desrep3/tools_ind.dbf   0  Full 4741673289 29-JUL-2004 16:40:09

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2543    368        532803040  0  532802932  392        29-JUL-2004 16:50:40

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2548    1   1   AVAILABLE   29-JUL-2004 16:50:40   /backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    2    /db01/oradata/desrep3/rbs.dbf         0  Full 4741673300 29-JUL-2004 16:48:53
    3    /db02/oradata/desrep3/des2.dbf        0  Full 4741673300 29-JUL-2004 16:48:53

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2544    369        532803041  0  532802932  393        29-JUL-2004 16:50:41

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2549    1   1   AVAILABLE   29-JUL-2004 16:50:41   /backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    1    /db00/oradata/desrep3/system.dbf      0  Full 4741673301 29-JUL-2004 16:48:53
    4    /db01/oradata/desrep3/des2_i.dbf      0  Full 4741673301 29-JUL-2004 16:48:53

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2545    370        532803058  0  532803052  395        29-JUL-2004 16:50:58

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2550    1   1   AVAILABLE   29-JUL-2004 16:50:58   /backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    8    /db00/oradata/desrep3/users.dbf       0  Full 4741673303 29-JUL-2004 16:50:52
    9    /db00/oradata/desrep3/TEST2.dbf       0  Full 4741673303 29-JUL-2004 16:50:52

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2546    371        532803065  0  532803051  394        29-JUL-2004 16:51:05

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2551    1   1   AVAILABLE   29-JUL-2004 16:51:05   /backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    5    /db01/oradata/desrep3/temp_1.dbf      0  Full 4741673302 29-JUL-2004 16:50:51
    6    /db01/oradata/desrep3/tools.dbf       0  Full 4741673302 29-JUL-2004 16:50:51

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2547    372        532803068  0  532803067  396        29-JUL-2004 16:51:08

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2552    1   1   AVAILABLE   29-JUL-2004 16:51:08   /backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk

    List of Datafiles Included
    File Name                                  LV Type Ckp SCN    Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    7    /db02/oradata/desrep3/tools_ind.dbf   0  Full 4741673304 29-JUL-2004 16:51:07

RMAN> list backup of archivelog all;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2518    365        532802421  0  532802420  389        29-JUL-2004 16:40:21

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2521    1   1   AVAILABLE   29-JUL-2004 16:40:21   /backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    10      4741673032 4741673199 22-JUL-2004 09:09:56 29-JUL-2004 14:21:57

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2519    366        532802421  0  532802420  390        29-JUL-2004 16:40:21

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2522    1   1   AVAILABLE   29-JUL-2004 16:40:21   /backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    11      4741673199 4741673201 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    12      4741673201 4741673204 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    13      4741673204 4741673225 29-JUL-2004 14:21:57 29-JUL-2004 16:02:41
    1    14      4741673225 4741673227 29-JUL-2004 16:02:41 29-JUL-2004 16:02:42
    1    15      4741673227 4741673230 29-JUL-2004 16:02:42 29-JUL-2004 16:02:42
    1    16      4741673230 4741673239 29-JUL-2004 16:02:42 29-JUL-2004 16:06:50
    1    17      4741673239 4741673241 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    18      4741673241 4741673244 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    19      4741673244 4741673257 29-JUL-2004 16:06:50 29-JUL-2004 16:18:04

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2520    367        532802422  0  532802422  391        29-JUL-2004 16:40:22

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2523    1   1   AVAILABLE   29-JUL-2004 16:40:22   /backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    20      4741673257 4741673259 29-JUL-2004 16:18:04 29-JUL-2004 16:18:05
    1    21      4741673259 4741673262 29-JUL-2004 16:18:05 29-JUL-2004 16:18:05
    1    22      4741673262 4741673274 29-JUL-2004 16:18:05 29-JUL-2004 16:26:30
    1    23      4741673274 4741673276 29-JUL-2004 16:26:30 29-JUL-2004 16:26:30
    1    24      4741673276 4741673279 29-JUL-2004 16:26:30 29-JUL-2004 16:26:31
    1    25      4741673279 4741673292 29-JUL-2004 16:26:31 29-JUL-2004 16:40:16
    1    26      4741673292 4741673294 29-JUL-2004 16:40:16 29-JUL-2004 16:40:17
    1    27      4741673294 4741673297 29-JUL-2004 16:40:17 29-JUL-2004 16:40:17

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2571    373        532803082  0  532803081  397        29-JUL-2004 16:51:22

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2574    1   1   AVAILABLE   29-JUL-2004 16:51:22   /backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    10      4741673032 4741673199 22-JUL-2004 09:09:56 29-JUL-2004 14:21:57

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2572    374        532803083  0  532803081  398        29-JUL-2004 16:51:23

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2575    1   1   AVAILABLE   29-JUL-2004 16:51:23   /backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    11      4741673199 4741673201 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    12      4741673201 4741673204 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    13      4741673204 4741673225 29-JUL-2004 14:21:57 29-JUL-2004 16:02:41
    1    14      4741673225 4741673227 29-JUL-2004 16:02:41 29-JUL-2004 16:02:42
    1    15      4741673227 4741673230 29-JUL-2004 16:02:42 29-JUL-2004 16:02:42
    1    16      4741673230 4741673239 29-JUL-2004 16:02:42 29-JUL-2004 16:06:50
    1    17      4741673239 4741673241 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    18      4741673241 4741673244 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    19      4741673244 4741673257 29-JUL-2004 16:06:50 29-JUL-2004 16:18:04
    1    20      4741673257 4741673259 29-JUL-2004 16:18:04 29-JUL-2004 16:18:05

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2573    375        532803084  0  532803083  399        29-JUL-2004 16:51:24

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2576    1   1   AVAILABLE   29-JUL-2004 16:51:24   /backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    21      4741673259 4741673262 29-JUL-2004 16:18:05 29-JUL-2004 16:18:05
    1    22      4741673262 4741673274 29-JUL-2004 16:18:05 29-JUL-2004 16:26:30
    1    23      4741673274 4741673276 29-JUL-2004 16:26:30 29-JUL-2004 16:26:30
    1    24      4741673276 4741673279 29-JUL-2004 16:26:30 29-JUL-2004 16:26:31
    1    25      4741673279 4741673292 29-JUL-2004 16:26:31 29-JUL-2004 16:40:16
    1    26      4741673292 4741673294 29-JUL-2004 16:40:16 29-JUL-2004 16:40:17
    1    27      4741673294 4741673297 29-JUL-2004 16:40:17 29-JUL-2004 16:40:17
    1    28      4741673297 4741673307 29-JUL-2004 16:40:17 29-JUL-2004 16:51:18
    1    29      4741673307 4741673309 29-JUL-2004 16:51:18 29-JUL-2004 16:51:18
    1    30      4741673309 4741673312 29-JUL-2004 16:51:18 29-JUL-2004 16:51:19

5: Changing the archive log set as "UNAVAILABLE"
   
RMAN> allocate channel for maintenance type disk;

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: delete
RMAN-08500: channel delete: sid=18 devtype=DISK

RMAN> change backupset 2518, 2571 unavailable;

RMAN-03022: compiling command: change
RMAN-06111: changed backup piece unavailable
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk recid=365 stamp=532802421
RMAN-06111: changed backup piece unavailable
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk recid=373 stamp=532803082

6. Move the archivelog backupset away.

$hostx::desrep3-/backup/DESREP3> ls
arch_DESREP3_t532802420_s389_p1_disk    df_DESREP3_t532802392_s386_p1_lv0_disk
arch_DESREP3_t532802420_s390_p1_disk    df_DESREP3_t532802393_s387_p1_lv0_disk
arch_DESREP3_t532802422_s391_p1_disk    df_DESREP3_t532802409_s388_p1_lv0_disk
arch_DESREP3_t532803081_s397_p1_disk    df_DESREP3_t532802932_s392_p1_lv0_disk
arch_DESREP3_t532803081_s398_p1_disk    df_DESREP3_t532802932_s393_p1_lv0_disk
arch_DESREP3_t532803083_s399_p1_disk    df_DESREP3_t532803051_s394_p1_lv0_disk
df_DESREP3_t532802281_s384_p1_lv0_disk  df_DESREP3_t532803052_s395_p1_lv0_disk
df_DESREP3_t532802281_s385_p1_lv0_disk  df_DESREP3_t532803067_s396_p1_lv0_disk

$hostx::desrep3-/backup/DESREP3> mv arch_DESREP3_t532802420_s389_p1_disk /tmp/.

$hostx::desrep3-/backup/DESREP3> mv arch_DESREP3_t532803081_s397_p1_disk /tmp/.

$hostx::desrep3-/backup/DESREP3> ls
arch_DESREP3_t532802420_s390_p1_disk    df_DESREP3_t532802393_s387_p1_lv0_disk
arch_DESREP3_t532802422_s391_p1_disk    df_DESREP3_t532802409_s388_p1_lv0_disk
arch_DESREP3_t532803081_s398_p1_disk    df_DESREP3_t532802932_s392_p1_lv0_disk
arch_DESREP3_t532803083_s399_p1_disk    df_DESREP3_t532802932_s393_p1_lv0_disk
df_DESREP3_t532802281_s384_p1_lv0_disk  df_DESREP3_t532803051_s394_p1_lv0_disk
df_DESREP3_t532802281_s385_p1_lv0_disk  df_DESREP3_t532803052_s395_p1_lv0_disk
df_DESREP3_t532802392_s386_p1_lv0_disk  df_DESREP3_t532803067_s396_p1_lv0_disk



7. Move the corresponding archivelogs away

$hostx::desrep3-/arch/desrep3/arch> ls
afiedt.buf          arch0000000021.arc  arch0000000033.arc  arch0000000045.arc
arch0000000010.arc  arch0000000022.arc  arch0000000034.arc  arch0000000046.arc
arch0000000011.arc  arch0000000023.arc  arch0000000035.arc  arch0000000047.arc
arch0000000012.arc  arch0000000024.arc  arch0000000036.arc  arch0000000048.arc
arch0000000013.arc  arch0000000025.arc  arch0000000037.arc  arch0000000049.arc
arch0000000014.arc  arch0000000026.arc  arch0000000038.arc  arch0000000050.arc
arch0000000015.arc  arch0000000027.arc  arch0000000039.arc  arch0000000051.arc
arch0000000016.arc  arch0000000028.arc  arch0000000040.arc  arch0000000052.arc
arch0000000017.arc  arch0000000029.arc  arch0000000041.arc  old
arch0000000018.arc  arch0000000030.arc  arch0000000042.arc
arch0000000019.arc  arch0000000031.arc  arch0000000043.arc
arch0000000020.arc  arch0000000032.arc  arch0000000044.arc
$hostx::desrep3-/arch/desrep3/arch> mv arch0000000010.arc  old/.
$hostx::desrep3-/arch/desrep3/arch> cd old
$hostx::desrep3-/arch/desrep3/arch/old> ls
arch0000000001.arc  arch0000000004.arc  arch0000000007.arc  arch0000000010.arc
arch0000000002.arc  arch0000000005.arc  arch0000000008.arc
arch0000000003.arc  arch0000000006.arc  arch0000000009.arc
$hostx::desrep3-/arch/desrep3/arch/old> cd ..
$hostx::desrep3-/arch/desrep3/arch> ls
afiedt.buf          arch0000000021.arc  arch0000000032.arc  arch0000000043.arc
arch0000000011.arc  arch0000000022.arc  arch0000000033.arc  arch0000000044.arc
arch0000000012.arc  arch0000000023.arc  arch0000000034.arc  arch0000000045.arc
arch0000000013.arc  arch0000000024.arc  arch0000000035.arc  arch0000000046.arc
arch0000000014.arc  arch0000000025.arc  arch0000000036.arc  arch0000000047.arc
arch0000000015.arc  arch0000000026.arc  arch0000000037.arc  arch0000000048.arc
arch0000000016.arc  arch0000000027.arc  arch0000000038.arc  arch0000000049.arc
arch0000000017.arc  arch0000000028.arc  arch0000000039.arc  arch0000000050.arc
arch0000000018.arc  arch0000000029.arc  arch0000000040.arc  arch0000000051.arc
arch0000000019.arc  arch0000000030.arc  arch0000000041.arc  arch0000000052.arc
arch0000000020.arc  arch0000000031.arc  arch0000000042.arc  old


8. Crosscheck the backups


RMAN> crosscheck backup of archivelog all;

RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk recid=366 stamp=532802421
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk recid=367 stamp=532802422
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk recid=374 stamp=532803083
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk recid=375 stamp=532803084
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete


9. Just run the validation

RMAN> run { execute script validate_restore_db_level_0; }

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-08031: released channel: d2
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script validate_restore_db_level_0
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 10 scn 4741673032 found to restore

10. Try deleting the archivelog backupset that was marked unavailable from RMAN
       
 RMAN> change backupset 2518, 2571 delete;

RMAN-03022: compiling command: change
RMAN-03023: executing command: DELETE
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03006: non-retryable error occurred during execution of command: change
RMAN-07004: unhandled exception during command execution on channel delete_02
RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED

RMAN> crosscheck backup of archivelog all;

RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk recid=366 stamp=532802421
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk recid=367 stamp=532802422
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk recid=374 stamp=532803083
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk recid=375 stamp=532803084
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN> change backupset 2518, 2571 delete;

RMAN-03022: compiling command: change
RMAN-03023: executing command: DELETE
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03006: non-retryable error occurred during execution of command: change
RMAN-07004: unhandled exception during command execution on channel delete_02
RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED

11. Run another crosscheck
     RMAN> crosscheck backup of archivelog all;

RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk recid=366 stamp=532802421
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk recid=367 stamp=532802422
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk recid=374 stamp=532803083
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk recid=375 stamp=532803084
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete


12. Run delete expired backups.

RMAN> delete expired backup;

RMAN-03022: compiling command: delete expired
RMAN-03023: executing command: delete expired


13. List backup of archive log  will show the status unavailable

RMAN> list backup of archivelog all;

RMAN-03022: compiling command: list

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2518    365        532802421  0  532802420  389        29-JUL-2004 16:40:21

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2521    1   1   UNAVAILABLE 29-JUL-2004 16:40:21   /backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    10      4741673032 4741673199 22-JUL-2004 09:09:56 29-JUL-2004 14:21:57

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2519    366        532802421  0  532802420  390        29-JUL-2004 16:40:21

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2522    1   1   AVAILABLE   29-JUL-2004 16:40:21   /backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    11      4741673199 4741673201 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    12      4741673201 4741673204 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    13      4741673204 4741673225 29-JUL-2004 14:21:57 29-JUL-2004 16:02:41
    1    14      4741673225 4741673227 29-JUL-2004 16:02:41 29-JUL-2004 16:02:42
    1    15      4741673227 4741673230 29-JUL-2004 16:02:42 29-JUL-2004 16:02:42
    1    16      4741673230 4741673239 29-JUL-2004 16:02:42 29-JUL-2004 16:06:50
    1    17      4741673239 4741673241 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    18      4741673241 4741673244 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    19      4741673244 4741673257 29-JUL-2004 16:06:50 29-JUL-2004 16:18:04

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2520    367        532802422  0  532802422  391        29-JUL-2004 16:40:22

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2523    1   1   AVAILABLE   29-JUL-2004 16:40:22   /backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    20      4741673257 4741673259 29-JUL-2004 16:18:04 29-JUL-2004 16:18:05
    1    21      4741673259 4741673262 29-JUL-2004 16:18:05 29-JUL-2004 16:18:05
    1    22      4741673262 4741673274 29-JUL-2004 16:18:05 29-JUL-2004 16:26:30
    1    23      4741673274 4741673276 29-JUL-2004 16:26:30 29-JUL-2004 16:26:30
    1    24      4741673276 4741673279 29-JUL-2004 16:26:30 29-JUL-2004 16:26:31
    1    25      4741673279 4741673292 29-JUL-2004 16:26:31 29-JUL-2004 16:40:16
    1    26      4741673292 4741673294 29-JUL-2004 16:40:16 29-JUL-2004 16:40:17
    1    27      4741673294 4741673297 29-JUL-2004 16:40:17 29-JUL-2004 16:40:17

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2571    373        532803082  0  532803081  397        29-JUL-2004 16:51:22

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2574    1   1   UNAVAILABLE 29-JUL-2004 16:51:22   /backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    10      4741673032 4741673199 22-JUL-2004 09:09:56 29-JUL-2004 14:21:57

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2572    374        532803083  0  532803081  398        29-JUL-2004 16:51:23

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2575    1   1   AVAILABLE   29-JUL-2004 16:51:23   /backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    11      4741673199 4741673201 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    12      4741673201 4741673204 29-JUL-2004 14:21:57 29-JUL-2004 14:21:57
    1    13      4741673204 4741673225 29-JUL-2004 14:21:57 29-JUL-2004 16:02:41
    1    14      4741673225 4741673227 29-JUL-2004 16:02:41 29-JUL-2004 16:02:42
    1    15      4741673227 4741673230 29-JUL-2004 16:02:42 29-JUL-2004 16:02:42
    1    16      4741673230 4741673239 29-JUL-2004 16:02:42 29-JUL-2004 16:06:50
    1    17      4741673239 4741673241 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    18      4741673241 4741673244 29-JUL-2004 16:06:50 29-JUL-2004 16:06:50
    1    19      4741673244 4741673257 29-JUL-2004 16:06:50 29-JUL-2004 16:18:04
    1    20      4741673257 4741673259 29-JUL-2004 16:18:04 29-JUL-2004 16:18:05

List of Backup Sets
Key     Recid      Stamp      LV Set Stamp  Set Count  Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2573    375        532803084  0  532803083  399        29-JUL-2004 16:51:24

    List of Backup Pieces
    Key     Pc# Cp# Status      Completion Time        Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2576    1   1   AVAILABLE   29-JUL-2004 16:51:24   /backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk

    List of Archived Logs Included
    Thrd Seq     Low SCN    Next SCN   Low Time        Next Time
    ---- ------- ---------- ---------- --------------- ---------------
    1    21      4741673259 4741673262 29-JUL-2004 16:18:05 29-JUL-2004 16:18:05
    1    22      4741673262 4741673274 29-JUL-2004 16:18:05 29-JUL-2004 16:26:30
    1    23      4741673274 4741673276 29-JUL-2004 16:26:30 29-JUL-2004 16:26:30
    1    24      4741673276 4741673279 29-JUL-2004 16:26:30 29-JUL-2004 16:26:31
    1    25      4741673279 4741673292 29-JUL-2004 16:26:31 29-JUL-2004 16:40:16
    1    26      4741673292 4741673294 29-JUL-2004 16:40:16 29-JUL-2004 16:40:17
    1    27      4741673294 4741673297 29-JUL-2004 16:40:17 29-JUL-2004 16:40:17
    1    28      4741673297 4741673307 29-JUL-2004 16:40:17 29-JUL-2004 16:51:18
    1    29      4741673307 4741673309 29-JUL-2004 16:51:18 29-JUL-2004 16:51:18
    1    30      4741673309 4741673312 29-JUL-2004 16:51:18 29-JUL-2004 16:51:19



14. run a validation process (it will fail)

RMAN> run { execute script validate_restore_db_level_0; }

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-08031: released channel: d2
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script validate_restore_db_level_0
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 10 scn 4741673032 found to restore

17.  Mark the backupset available

RMAN> change backupset 2518, 2571 available;

RMAN-03022: compiling command: change
RMAN-06115: changed backup piece available
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk recid=365 stamp=532802421
RMAN-06115: changed backup piece available
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk recid=373 stamp=532803082
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
           

17. Run a crosscheck, this time it will expire it for you

RMAN> crosscheck backup of archivelog all;

RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk recid=366 stamp=532802421
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk recid=367 stamp=532802422
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk recid=374 stamp=532803083
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk recid=375 stamp=532803084
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk recid=365 stamp=532802421
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk recid=373 stamp=532803082
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

18. Run the validation now

    RMAN> run { execute script validate_restore_db_level_0; }

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-08031: released channel: d2
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script validate_restore_db_level_0
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 10 scn 4741673032 found to restore

19. Now Delete the expired backup
 
RMAN> delete expired backup;

RMAN-03022: compiling command: delete expired
RMAN-03023: executing command: delete expired
RMAN-08073: deleted backup piece
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s389_p1_disk recid=365 stamp=532802421
RMAN-08073: deleted backup piece
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s397_p1_disk recid=373 stamp=532803082
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

20. Try the validation it would fail
RMAN> run { execute script validate_restore_db_level_0; }

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-08031: released channel: d2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script validate_restore_db_level_0
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 10 scn 4741673032 found to restore

21. Do a crosscheck on archivelog 
RMAN> change archivelog all crosscheck
2> ;

RMAN-03022: compiling command: change
RMAN-06157: validation failed for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000010.arc recid=117 stamp=532794117
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000011.arc recid=118 stamp=532794117
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000012.arc recid=119 stamp=532794118
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000013.arc recid=120 stamp=532800162
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000014.arc recid=121 stamp=532800162
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000015.arc recid=122 stamp=532800162
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000016.arc recid=123 stamp=532800410
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000017.arc recid=124 stamp=532800410
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000018.arc recid=125 stamp=532800410
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000019.arc recid=126 stamp=532801084
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000020.arc recid=127 stamp=532801085
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000021.arc recid=128 stamp=532801085
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000022.arc recid=129 stamp=532801590
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000023.arc recid=130 stamp=532801590
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000024.arc recid=131 stamp=532801591
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000025.arc recid=132 stamp=532802417
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000026.arc recid=133 stamp=532802417
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000027.arc recid=134 stamp=532802417
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000028.arc recid=135 stamp=532803079
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000029.arc recid=136 stamp=532803079
RMAN-06158: validation succeeded for archived log
RMAN-08514: archivelog filename=/oracle/admin/desrep3/arch/arch0000000030.arc recid=137 stamp=532803079

22. Do a crosscheck of backup


RMAN> crosscheck backup of archivelog all;

RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802420_s390_p1_disk recid=366 stamp=532802421
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532802422_s391_p1_disk recid=367 stamp=532802422
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803081_s398_p1_disk recid=374 stamp=532803083
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece handle=/backup/DESREP3/arch_DESREP3_t532803083_s399_p1_disk recid=375 stamp=532803084
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

23. Now run the validation 

RMAN> run { execute script validate_restore_db_level_0; }

RMAN-03021: executing script: validate_restore_db_level_0

RMAN-03021: executing script: allocate_2_tapes

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=15 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 5.2.0.0

RMAN-03021: executing script: allocate_2_disks

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=12 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=393 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=392 set_stamp=532802932 creation_time=29-JUL-2004 16:48:52
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s393_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete
RMAN-08096: channel d1: starting validation of datafile backupset
RMAN-08502: set_count=394 set_stamp=532803051 creation_time=29-JUL-2004 16:50:51
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532802932_s392_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=395 set_stamp=532803052 creation_time=29-JUL-2004 16:50:52
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803052_s395_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08096: channel d2: starting validation of datafile backupset
RMAN-08502: set_count=396 set_stamp=532803067 creation_time=29-JUL-2004 16:51:07
RMAN-08023: channel d2: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803067_s396_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d2: validation complete
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/DESREP3/df_DESREP3_t532803051_s394_p1_lv0_disk tag=LEVEL_0_DISK params=NULL
RMAN-08098: channel d1: validation complete

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000011.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000012.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000013.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000014.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000015.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000016.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000017.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000018.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000019.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000020.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000021.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000022.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000023.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000024.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000025.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000026.arc
RMAN-08520: channel t1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000027.arc
RMAN-08520: channel t2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000028.arc
RMAN-08520: channel d1: scanning archivelog /oracle/admin/desrep3/arch/arch0000000029.arc
RMAN-08520: channel d2: scanning archivelog /oracle/admin/desrep3/arch/arch0000000030.arc

RMAN-03021: executing script: release_2_disks

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d2

RMAN-03021: executing script: release_2_tapes

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t2

